2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 006 #BIReleases2013

Release Notes

8481.700 - Assist with Crystal Report updates

Admin Info

---

Purpose	Need to update Crystal reports from 7.0 to 7.3 for sales analysis, open orders and service levels
Release No	006
Submitted	10/03/2013
Submitted by	Naga Ramineni
Source/Destination Systems	NBP to BPD
Release Sent To	Jack Mehltretter
Object(s) Created By	Naga Ramineni
Object(s) Tested By	Naga Ramineni

Report Name(s)

---

Below are the list of Crystal Reports and their respective BW 7.0 Production and BW 7.3 Development queries:

SNo	Folder	Report	Source	BW Query	New BW Query
1.	Open Orders	OSA100 - Open Orders by Date	BW	ZMP_OOCON_Q003	ZMP_OOCON_Q001
2.	Open Orders	OSA110 – Open Orders by Country and Sales Rep	BW	ZMP_OOCON_Q006	ZMP_OOCON_Q002
3.	Open Orders	OSA130 - Open Orders by Season, Collection, and Material	BW	ZMP_OOCON_Q004	ZMP_OOCON_Q003
4.	Open Orders	OSA131 - Hot Market Open Orders by Collection, Team, and Material	BW	ZMP_OOCON_Q002	ZMP_OOCON_Q004
5.	Open Orders	OSA132 – Open Orders by Season Collection Material by Month	BW	ZMP_OOCON_Q004	ZMP_OOCON_Q005
7.	Open Orders	OSA172 - Open Orders at risk of Cancel	BW	ZMP_OOCON_Q021	ZMP_OOCON_Q012
8.	Open Orders	OSA175 - Open Orders by Sales Rep and Customer	BW	ZMP_OOCON_Q007	ZMP_OOCON_Q006
9.	Open Orders	OSA180 - Open Orders by Plant	BW	ZMP_OOCON_Q008	ZMP_OOCON_Q007
10.	Open Orders	OSA181 - Open Orders by Plant and Customer	BW	ZMP_OOCON_Q008	ZMP_OOCON_Q007
13.	Open Orders	OSA350 - Open Orders for Hot Market	BW	ZMP_OPASA_Q032	ZMP_OOCON_Q008
14.	Open Orders	OSA500 - Cancelled Orders by Year, Fiscal Period, Sales Rep and Customer	BW	ZAFSDDS1_Q004	ZAFSDDS1_Q001
16.	Open Orders	OSA900 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season and Collection	BW	ZMP_OPASA_Q030	ZMP_OOCON_Q009
17.	Open Orders	OSA905 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season, Collection and Material	BW	ZMP_OPASA_Q030	ZMP_OOCON_Q009
18.	Open Orders	OSA910 - Open Orders by Sales Org, SBU, Sport, License, Team and Style	BW	ZMP_OPASA_Q031	ZMP_OOCON_Q010
19.	Open Orders	OSA915 - Open Orders by Sales Org, SBU, Sport, License, Team, Style and Material	BW	ZMP_OPASA_Q031	ZMP_OOCON_Q010
20.	Open Orders	OSA920 - Open Order by by Sales Org, Sales Manager, Style, License, Sales Rep and Account	BW	ZMP_OPASA_Q033	ZMP_OOCON_Q011

Release Notes

---

For Infrastructure

None

For Requestor

Updated Crystal Reports are placed in IT > BMS > Production > BPD folder.

Test Notes

No need to validate the above reports, untill the sources in BW are moved to quality.

Reference Document(Specification)

---

2013-09-11 - 8481.700 - Spec - Assist with Crystal Report updates
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 001
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 002
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 003
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 004
2013-09-11 - 8481.700 - Rel Notes - Assist with Crystal Report updates - Release 005